Storing data from database [mysql_num_rows]
Posted
by
user1717305
on Stack Overflow
See other posts from Stack Overflow
or by user1717305
Published on 2012-10-14T03:19:35Z
Indexed on
2012/10/14
3:37 UTC
Read the original article
Hit count: 70
php
|mysql-num-rows
So I have this code to pass items from database to my order table. When I'm echoing the session. The session variable contains something so there's no problem with that. But when I echo those variables under numrows, it only shows nothing. Is there something wrong?
<?php
error_reporting(E_ALL ^ E_NOTICE);
session_start();
require("connect.php");
$UserID = $_SESSION['CustNum'];
$UserN = $_SESSION['UserName'];
$ProdGTotal = $_SESSION['ProdGTotal'];
$queryord = mysql_query("SELECT * FROM customer WHERE UserName = '$UserN'");
$numrows = mysql_num_rows($queryord);
if(numrows == 1){
$row = mysql_fetch_assoc($queryord)or die ('Unable to run query:'.mysql_error()); // fetch associated: get function from a query for a database
$dbstreet = $row['Street'];
$dhousenum = $row['HouseNum'];
$dbcnum = $row['CelNum'];
$dbarea = $row['Area'];
$dbbuilding = $row['Building'];
$dbcity = $row['City'];
$dbpnum = $row['PhoneNum'];
$dbfname = $row['FName'];
$dblname = $row['LName'];
}
else
die(mysql_error());
$query4=mysql_query("INSERT INTO orderdetails VALUES ('', '$UserID', Now(), '$dbhousenum', '$dbstreet', '$dbarea', '$dbbuilding', '$dbcity', '$dbfname', '$dblname', '$dbcnum', '$dbpnum', '$ProdGTotal')",$connect);
if ($query4){
header("location:index.php");
}
else
die(mysql_error());
?>
© Stack Overflow or respective owner